<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">  
  <title>用户列表</title>
  <link rel="stylesheet" type="text/css" href="../css/bootstrap.min.css">
 </head>
 <body>
 
 <?php
  require_once('inc_admin.php');
  require_once('menu.php');
  connect();
  //编写sql语句
  $sql = 'select uid, uname, gender, birthdate, hobby, degree, intro, pic from users';
  //echo $sql.'<br/>';  
  $result = fetch_array($sql); 
   
 ?>
 <div class="container">
   <div class="row">
     <h1 class="text-center">用户列表</h1>
     <table class="table table-hover"> 
     <tr>
       <th>用户编号</th>
       <th>用户名</th>   
       <th>性别</th>
       <th>生日</th>
       <th>爱好</th>
       <th>学历</th>
       <th>自我介绍</th> 
       <th width='80'>头像</th>
       <th>操作</th>
     </tr>

     <?php
      foreach ($result as $row) {
    	 echo '<tr>';
    	 echo '<td>'.$row['uid'].'</td>';
    	 echo '<td>'.$row['uname'].'</td>';	 
    	 echo '<td>'.($row['gender']==0?'男':'女').'</td>';
    	 echo '<td>'.$row['birthdate'].'</td>';
    	 echo '<td>'.$row['hobby'].'</td>';
    	 switch($row['degree']){
    	   case '1':$dg = "高中";break;
    	   case '2':$dg = "大学";break;
    	   case '3':$dg = "研究生";break;
    	   case '4':$dg = "博士生";break;
    	   default: $dg="不知道";
         }
    	 echo '<td>'.$dg.'</td>';
    	 echo '<td>'.$row['intro'].'</td>';	 	 
    	 echo '<td align="center"><img src='.$row['pic'].' width=60 height=80 alt="无头像"></td>';	 
    	 echo '<td><a href="userEditForm.php?id='.$row['uid'].' ">修改</a> | 
    	 <a href="userDelete.php?id='.$row['uid'].'" onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';
    	 echo '</tr>';  
      }
      echo '</table>';  
      $totalrows = count($result);
      echo "<table align='center'><tr><td>共有{$totalrows}名用户</td></tr></table>";   
     ?>
  </div>
 </div>
 </body>
</html>